from sqlalchemy import Column
from sqlalchemy.sql.sqltypes import Integer, String, Text, TIMESTAMP
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()

class PurchaseLand(Base):
    __tablename__ = "TYC_M_PURCHASE_LAND"
    LANDLEVEL = Column(String(255))
    CHAINLINK = Column(String(4000))
    LANDSOURCEVIEW = Column(String(255))
    PROJECTLOCATION = Column(String(255))
    LANDUSETYPE = Column(String(255))
    ELECTRONICREGULATORYNUMBER = Column(String(255))
    LANDUSERIGHTPERSON = Column(String(255))
    LANDUSEPERIOD = Column(String(255))
    TRANSACTIONPRICE = Column(String(255))
    INSTALMENTPAYMENT = Column(Text)
    CONTRACTEDVOLUMERATE = Column(String(255))
    COMMITTEDTIME = Column(Integer)
    AUTHORITY = Column(String(255))
    CONTRACTDATE = Column(Integer)
    CATEGORY = Column(String(255))
    AREA = Column(String(255))
    COMPANYLIST = Column(Text)
    LANDSUPPLYMETHOD = Column(String(255))
    DISTRICT = Column(String(255))
    PROJECTNAME = Column(String(255))
    CONTRACTEDVOLUMERATECEILING = Column(String(255))
    AGREEMENTSTARTTIME = Column(Integer)
    SCHEDULEDCOMPLETION = Column(Integer)

    ENTNAME = Column(String(100))
    PRIPID = Column(String(36))
    REGNO = Column(String(50))
    UNISCID = Column(String(18))
    CREATE_TIME = Column(TIMESTAMP)
    UPDATE_TIME = Column(TIMESTAMP)